Skip Headers

Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# FLOOR

The FLOOR function returns the largest whole number equal to or less than a specified number.

Return Value

NUMBER

Syntax

FLOOR(n)

Arguments

n

  A whole number (`NUMBER` data type) that you specify.

Examples

Example 13-23 Displaying the Largest Integer Equal to or Less Than a Number

The following statements show results returned by the FLOOR function.

- The following `SHOW FLOOR` statement produces the result that follows it.

      SHOW FLOOR(15.7)

      15

- The following `SHOW FLOOR` statement produces the result that follows it.

      SHOW FLOOR(4)

      4

- The following `SHOW FLOOR` statement produces the result that follows it.

      SHOW FLOOR(-6.457)

      -7